{
  "properties" : { },
  "id" : "a4c723f5557e4454a175906ea7b42304",
  "script" : null,
  "groupId" : "8bef99c4757b4832b18db52e53ef9b4b",
  "name" : "操作日志",
  "createTime" : 1727071023920,
  "updateTime" : 1726728296804,
  "lock" : "1",
  "createBy" : "ndmp",
  "updateBy" : "ndmp",
  "path" : "syslog",
  "method" : "GET",
  "parameters" : [ {
    "name" : "init",
    "value" : "1",
    "description" : "",
    "required" : true,
    "dataType" : "Integer",
    "type" : "",
    "defaultValue" : "",
    "validateType" : "",
    "error" : "",
    "expression" : "",
    "children" : [ ]
  }, {
    "name" : "queryPage",
    "value" : "1",
    "description" : "",
    "required" : false,
    "dataType" : "Integer",
    "type" : "",
    "defaultValue" : "",
    "validateType" : "",
    "error" : "",
    "expression" : "",
    "children" : [ ]
  }, {
    "name" : "querySize",
    "value" : "30",
    "description" : null,
    "required" : false,
    "dataType" : "Integer",
    "type" : null,
    "defaultValue" : null,
    "validateType" : null,
    "error" : null,
    "expression" : null,
    "children" : null
  }, {
    "name" : "operatorName",
    "value" : "管理员",
    "description" : null,
    "required" : false,
    "dataType" : "String",
    "type" : null,
    "defaultValue" : null,
    "validateType" : null,
    "error" : null,
    "expression" : null,
    "children" : null
  }, {
    "name" : "eventType",
    "value" : "查询",
    "description" : null,
    "required" : false,
    "dataType" : "String",
    "type" : null,
    "defaultValue" : null,
    "validateType" : null,
    "error" : null,
    "expression" : null,
    "children" : null
  } ],
  "options" : [ ],
  "requestBody" : "",
  "headers" : [ ],
  "paths" : [ ],
  "responseBody" : "{\n    \"resultCode\": 200,\n    \"resultMessage\": \"ok\",\n    \"resultObject\": {\n        \"page\": 30,\n        \"pageCounts\": 1,\n        \"total\": 265,\n        \"body\": [\n            {\n                \"id\": \"1836657486966665216\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:44:02\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/查询下发结果操作\",\n                \"rowId\": \"1\"\n            },\n            {\n                \"id\": \"1836657436169449472\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:43:50\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/查询下发结果操作\",\n                \"rowId\": \"2\"\n            },\n            {\n                \"id\": \"1836657429433397248\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:43:49\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/查询下发结果操作\",\n                \"rowId\": \"3\"\n            },\n            {\n                \"id\": \"1836657361187876864\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:43:33\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/查询下发结果操作\",\n                \"rowId\": \"4\"\n            },\n            {\n                \"id\": \"1836657310399049728\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:43:20\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/查询下发结果操作\",\n                \"rowId\": \"5\"\n            },\n            {\n                \"id\": \"1836657303595888640\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:43:19\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/查询下发结果操作\",\n                \"rowId\": \"6\"\n            },\n            {\n                \"id\": \"1836657235383922688\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:43:03\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/查询下发结果操作\",\n                \"rowId\": \"7\"\n            },\n            {\n                \"id\": \"1836657207663767552\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:42:56\",\n                \"content\": \"管理员使用账号(admin)进行了/3.陕西/问题记录/查询具体信息操作\",\n                \"rowId\": \"8\"\n            },\n            {\n                \"id\": \"1836657193176641536\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:42:52\",\n                \"content\": \"管理员使用账号(admin)进行了/3.陕西/问题记录/分页查询操作\",\n                \"rowId\": \"9\"\n            },\n            {\n                \"id\": \"1836657193046618112\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:42:52\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/首页/查询调度机构列表操作\",\n                \"rowId\": \"10\"\n            },\n            {\n                \"id\": \"1836657184557346816\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:42:50\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/查询下发结果操作\",\n                \"rowId\": \"11\"\n            },\n            {\n                \"id\": \"1836657177749991424\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:42:49\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/查询下发结果操作\",\n                \"rowId\": \"12\"\n            },\n            {\n                \"id\": \"1836657125262471168\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.115\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"其他\",\n                \"time\": \"2024-09-19 14:42:36\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/首页/流量状态操作\",\n                \"rowId\": \"13\"\n            },\n            {\n                \"id\": \"1836657109546414080\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:42:33\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/查询下发结果操作\",\n                \"rowId\": \"14\"\n            },\n            {\n                \"id\": \"1836657109399613440\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:42:32\",\n                \"content\": \"管理员使用账号(admin)进行了/3.陕西/问题记录/分页查询操作\",\n                \"rowId\": \"15\"\n            },\n            {\n                \"id\": \"1836657058724032512\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:42:20\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/查询下发结果操作\",\n                \"rowId\": \"16\"\n            },\n            {\n                \"id\": \"1836657051929260032\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:42:19\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/查询下发结果操作\",\n                \"rowId\": \"17\"\n            },\n            {\n                \"id\": \"1836657020463591424\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.115\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"其他\",\n                \"time\": \"2024-09-19 14:42:11\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/首页/流量状态操作\",\n                \"rowId\": \"18\"\n            },\n            {\n                \"id\": \"1836656983658573824\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:42:02\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/查询下发结果操作\",\n                \"rowId\": \"19\"\n            },\n            {\n                \"id\": \"1836656978814152704\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.115\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"其他\",\n                \"time\": \"2024-09-19 14:42:01\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/首页/流量状态操作\",\n                \"rowId\": \"20\"\n            },\n            {\n                \"id\": \"1836656950695538688\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"其他\",\n                \"time\": \"2024-09-19 14:41:55\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/下发操作\",\n                \"rowId\": \"21\"\n            },\n            {\n                \"id\": \"1836656932890718208\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:41:50\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/查询下发结果操作\",\n                \"rowId\": \"22\"\n            },\n            {\n                \"id\": \"1836656926121111552\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:41:49\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/查询下发结果操作\",\n                \"rowId\": \"23\"\n            },\n            {\n                \"id\": \"1836656873168023552\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:41:36\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/告警模块/告警规则/查询规则列表操作\",\n                \"rowId\": \"24\"\n            },\n            {\n                \"id\": \"1836656871452553216\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"新增\",\n                \"time\": \"2024-09-19 14:41:36\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/告警模块/告警规则/新增告警规则操作\",\n                \"rowId\": \"25\"\n            },\n            {\n                \"id\": \"1836656858081112064\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:41:33\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/查询下发结果操作\",\n                \"rowId\": \"26\"\n            },\n            {\n                \"id\": \"1836656807028043776\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:41:20\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/查询下发结果操作\",\n                \"rowId\": \"27\"\n            },\n            {\n                \"id\": \"1836656800254242816\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"192.100.5.101\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:41:19\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/配置管理/配置下发/查询下发结果操作\",\n                \"rowId\": \"28\"\n            },\n            {\n                \"id\": \"1836656756142747648\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:41:08\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/告警模块/告警级别/查询告警级别列表操作\",\n                \"rowId\": \"29\"\n            },\n            {\n                \"id\": \"1836656755274526720\",\n                \"operatorname\": \"管理员\",\n                \"account\": \"admin\",\n                \"operatorip\": \"\",\n                \"deviceip\": \"\",\n                \"eventtype\": \"查询\",\n                \"time\": \"2024-09-19 14:41:08\",\n                \"content\": \"管理员使用账号(admin)进行了/1.公共/告警模块/告警规则/查询规则列表操作\",\n                \"rowId\": \"30\"\n            }\n        ]\n    },\n    \"success\": true\n}",
  "description" : "",
  "requestBodyDefinition" : {
    "name" : null,
    "value" : null,
    "description" : null,
    "required" : false,
    "dataType" : "String",
    "type" : null,
    "defaultValue" : null,
    "validateType" : null,
    "error" : null,
    "expression" : null,
    "children" : null
  },
  "responseBodyDefinition" : {
    "name" : "",
    "value" : "",
    "description" : "",
    "required" : false,
    "dataType" : "Object",
    "type" : null,
    "defaultValue" : "",
    "validateType" : "",
    "error" : "",
    "expression" : "",
    "children" : [ {
      "name" : "resultCode",
      "value" : "200",
      "description" : "",
      "required" : false,
      "dataType" : "Integer",
      "type" : null,
      "defaultValue" : null,
      "validateType" : "",
      "error" : "",
      "expression" : "",
      "children" : [ ]
    }, {
      "name" : "resultMessage",
      "value" : "ok",
      "description" : "",
      "required" : false,
      "dataType" : "String",
      "type" : null,
      "defaultValue" : null,
      "validateType" : "",
      "error" : "",
      "expression" : "",
      "children" : [ ]
    }, {
      "name" : "resultObject",
      "value" : "",
      "description" : "",
      "required" : false,
      "dataType" : "Object",
      "type" : null,
      "defaultValue" : null,
      "validateType" : "",
      "error" : "",
      "expression" : "",
      "children" : [ {
        "name" : "page",
        "value" : "30",
        "description" : "",
        "required" : false,
        "dataType" : "Integer",
        "type" : null,
        "defaultValue" : null,
        "validateType" : "",
        "error" : "",
        "expression" : "",
        "children" : [ ]
      }, {
        "name" : "pageCounts",
        "value" : "1",
        "description" : "",
        "required" : false,
        "dataType" : "Integer",
        "type" : null,
        "defaultValue" : null,
        "validateType" : "",
        "error" : "",
        "expression" : "",
        "children" : [ ]
      }, {
        "name" : "total",
        "value" : "177",
        "description" : "",
        "required" : false,
        "dataType" : "Integer",
        "type" : null,
        "defaultValue" : null,
        "validateType" : "",
        "error" : "",
        "expression" : "",
        "children" : [ ]
      }, {
        "name" : "body",
        "value" : "",
        "description" : "",
        "required" : false,
        "dataType" : "Array",
        "type" : null,
        "defaultValue" : null,
        "validateType" : "",
        "error" : "",
        "expression" : "",
        "children" : [ {
          "name" : "",
          "value" : "",
          "description" : "",
          "required" : false,
          "dataType" : "Object",
          "type" : null,
          "defaultValue" : null,
          "validateType" : "",
          "error" : "",
          "expression" : "",
          "children" : [ {
            "name" : "id",
            "value" : "1836654687721730048",
            "description" : "",
            "required" : false,
            "dataType" : "String",
            "type" : null,
            "defaultValue" : null,
            "validateType" : "",
            "error" : "",
            "expression" : "",
            "children" : [ ]
          }, {
            "name" : "operatorname",
            "value" : "管理员",
            "description" : "",
            "required" : false,
            "dataType" : "String",
            "type" : null,
            "defaultValue" : null,
            "validateType" : "",
            "error" : "",
            "expression" : "",
            "children" : [ ]
          }, {
            "name" : "account",
            "value" : "admin",
            "description" : "",
            "required" : false,
            "dataType" : "String",
            "type" : null,
            "defaultValue" : null,
            "validateType" : "",
            "error" : "",
            "expression" : "",
            "children" : [ ]
          }, {
            "name" : "operatorip",
            "value" : "",
            "description" : "",
            "required" : false,
            "dataType" : "String",
            "type" : null,
            "defaultValue" : null,
            "validateType" : "",
            "error" : "",
            "expression" : "",
            "children" : [ ]
          }, {
            "name" : "deviceip",
            "value" : "",
            "description" : "",
            "required" : false,
            "dataType" : "String",
            "type" : null,
            "defaultValue" : null,
            "validateType" : "",
            "error" : "",
            "expression" : "",
            "children" : [ ]
          }, {
            "name" : "eventtype",
            "value" : "查询",
            "description" : "",
            "required" : false,
            "dataType" : "String",
            "type" : null,
            "defaultValue" : null,
            "validateType" : "",
            "error" : "",
            "expression" : "",
            "children" : [ ]
          }, {
            "name" : "time",
            "value" : "2024-09-19 14:32:55",
            "description" : "",
            "required" : false,
            "dataType" : "String",
            "type" : null,
            "defaultValue" : null,
            "validateType" : "",
            "error" : "",
            "expression" : "",
            "children" : [ ]
          }, {
            "name" : "content",
            "value" : "管理员使用账号(admin)进行了/1.公共/自动发现/ip范围配置/查询操作",
            "description" : "",
            "required" : false,
            "dataType" : "String",
            "type" : null,
            "defaultValue" : null,
            "validateType" : "",
            "error" : "",
            "expression" : "",
            "children" : [ ]
          }, {
            "name" : "rowId",
            "value" : "1",
            "description" : "",
            "required" : false,
            "dataType" : "String",
            "type" : null,
            "defaultValue" : null,
            "validateType" : "",
            "error" : "",
            "expression" : "",
            "children" : [ ]
          } ]
        } ]
      } ]
    }, {
      "name" : "success",
      "value" : "true",
      "description" : "",
      "required" : false,
      "dataType" : "Boolean",
      "type" : null,
      "defaultValue" : "",
      "validateType" : "",
      "error" : "",
      "expression" : "",
      "children" : [ ]
    } ]
  }
}
================================
import response;
var sql = """
SELECT
        o.id as id,
        o.operator_name as operatorName,
        o.account as account,
        o.operator_ip as operatorIp,
        o.device_ip as deviceIp,
        o.event_type as eventType,
        o.time as time,
        o.content as content
    FROM
        ndmp_operator_log o
    WHERE
        1=1
        <if test="operatorName != null and  operatorName !=''">
            AND o.operator_name LIKE '%${ operatorName}%'
        </if>
        <if test=" eventType != null and  eventType !=''">
            AND o.event_type LIKE '%${ eventType}%'
        </if>
        <if test=" startTime != null and  startTime !=''">
            AND o.time >= '${ startTime}'
        </if>
        <if test=" endTime != null and  endTime !=''">
            AND o.time <= '${ endTime}'
        </if>
        <if test=" operatorIp != null and  operatorIp !=''">
            AND o.operator_ip LIKE '%${ operatorIp}%'
        </if>
        order by time desc
"""
var a = db.page(sql, querySize, queryPage - 1);
if (a == null) {
    return response.json({
        "resultCode": 200,
        "resultMessage": "ok",
        "resultObject": {
            "page": 1,
            "pageCounts": 0,
            "total": 0,
            "body": []
        },
        "success": true
    })
}
var result = {
    "page": a.size,
    "pageCounts": a.current,
    "total": a.total,
    "body": a.records
}

return response.json({
    "resultCode": 200,
    "resultMessage": "ok",
    "resultObject": result,
    "success": true
})